Airbnb Data Exploration

Dataset statistics

Number of variables	17
Number of observations	9999
Missing cells	3954
Missing cells (%)	2.3%
Duplicate rows	0
Duplicate rows (%)	0.0%
Total size in memory	1.3 MiB
Average record size in memory	136.0 B

Variable types

Numeric	12
Categorical	5

Alerts

`name` has a high cardinality: 9791 distinct values	High cardinality
`host_name` has a high cardinality: 2851 distinct values	High cardinality
`last_review` has a high cardinality: 2010 distinct values	High cardinality
`id` is highly correlated with `host_id`	High correlation
`host_id` is highly correlated with `id`	High correlation
`price` is highly correlated with `log_price`	High correlation
`minimum_nights` is highly correlated with `number_of_reviews`	High correlation
`number_of_reviews` is highly correlated with `minimum_nights` and 3 other fields	High correlation
`reviews_per_month` is highly correlated with `number_of_reviews` and 1 other fields	High correlation
`availability_365` is highly correlated with `number_of_reviews` and 1 other fields	High correlation
`number_of_reviews_ltm` is highly correlated with `number_of_reviews` and 2 other fields	High correlation
`log_price` is highly correlated with `price`	High correlation
`price` is highly correlated with `log_price`	High correlation
`number_of_reviews` is highly correlated with `reviews_per_month` and 1 other fields	High correlation
`reviews_per_month` is highly correlated with `number_of_reviews` and 1 other fields	High correlation
`number_of_reviews_ltm` is highly correlated with `number_of_reviews` and 1 other fields	High correlation
`log_price` is highly correlated with `price`	High correlation
`id` is highly correlated with `host_id`	High correlation
`host_id` is highly correlated with `id`	High correlation
`price` is highly correlated with `log_price`	High correlation
`number_of_reviews` is highly correlated with `reviews_per_month` and 1 other fields	High correlation
`reviews_per_month` is highly correlated with `number_of_reviews` and 1 other fields	High correlation
`number_of_reviews_ltm` is highly correlated with `number_of_reviews` and 1 other fields	High correlation
`log_price` is highly correlated with `price`	High correlation
`id` is highly correlated with `host_id`	High correlation
`host_id` is highly correlated with `id`	High correlation
`neighbourhood` is highly correlated with `latitude` and 1 other fields	High correlation
`latitude` is highly correlated with `neighbourhood` and 1 other fields	High correlation
`longitude` is highly correlated with `neighbourhood` and 1 other fields	High correlation
`price` is highly correlated with `log_price`	High correlation
`number_of_reviews` is highly correlated with `reviews_per_month` and 1 other fields	High correlation
`reviews_per_month` is highly correlated with `number_of_reviews` and 1 other fields	High correlation
`number_of_reviews_ltm` is highly correlated with `number_of_reviews` and 1 other fields	High correlation
`log_price` is highly correlated with `price`	High correlation
`last_review` has 1958 (19.6%) missing values	Missing
`reviews_per_month` has 1958 (19.6%) missing values	Missing
`price` is highly skewed (γ1 = 26.55905346)	Skewed
`name` is uniformly distributed	Uniform
`id` has unique values	Unique
`number_of_reviews` has 1958 (19.6%) zeros	Zeros
`availability_365` has 5721 (57.2%) zeros	Zeros
`number_of_reviews_ltm` has 6974 (69.7%) zeros	Zeros

Reproduction

Analysis started	2022-02-17 15:05:03.922068
Analysis finished	2022-02-17 15:05:30.470097
Duration	26.55 seconds
Software version	pandas-profiling v3.1.0
Download configuration	config.json

id
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
UNIQUE

Distinct	9999
Distinct (%)	100.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	4887275.145

Minimum	5396
Maximum	9492265
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	78.2 KiB

Quantile statistics

Minimum	5396
5-th percentile	554565.2
Q1	2567391
median	5149727
Q3	7155202
95-th percentile	8987572.9
Maximum	9492265
Range	9486869
Interquartile range (IQR)	4587811

Descriptive statistics

Standard deviation	2701832.897
Coefficient of variation (CV)	0.5528301183
Kurtosis	-1.198620243
Mean	4887275.145
Median Absolute Deviation (MAD)	2181178
Skewness	-0.163297159
Sum	4.886786418 × 10¹⁰
Variance	7.299901001 × 10¹²
Monotonicity	Strictly increasing

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
6986367	1	< 0.1%
7641782	1	< 0.1%
6709929	1	< 0.1%
7058091	1	< 0.1%
7847720	1	< 0.1%
4676270	1	< 0.1%
7376362	1	< 0.1%
9247895	1	< 0.1%
9433068	1	< 0.1%
7295671	1	< 0.1%
Other values (9989)	9989	99.9%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
5396	1	< 0.1%
7397	1	< 0.1%
7964	1	< 0.1%
9359	1	< 0.1%
9952	1	< 0.1%
10586	1	< 0.1%
10588	1	< 0.1%
10917	1	< 0.1%
11213	1	< 0.1%
11265	1	< 0.1%

Value	Count	Frequency (%)
9492265	1	< 0.1%
9489895	1	< 0.1%
9488190	1	< 0.1%
9487744	1	< 0.1%
9487739	1	< 0.1%
9487619	1	< 0.1%
9487360	1	< 0.1%
9487232	1	< 0.1%
9486445	1	< 0.1%
9486388	1	< 0.1%

name
Categorical

HIGH CARDINALITY
UNIFORM

Distinct	9791
Distinct (%)	98.2%
Missing	30
Missing (%)	0.3%
Memory size	78.2 KiB

StudiointheheartofParis	8
CosyflatinMontmartre	7
CharmingflatnearMontmartre	6
CharmingflatintheheartofParis	5
CharmingflatinMontmartre	5
Other values (9786)	9938

Length

Max length	68
Median length	28
Mean length	28.24606279
Min length	2

Characters and Unicode

Total characters	0
Distinct characters	0
Distinct categories	0 ?
Distinct scripts	0 ?
Distinct blocks	0 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	9665 ?
Unique (%)	97.0%

Sample

1st row	ExploretheheartofoldParis
2nd row	MARAIS-2ROOMSAPT-2/4PEOPLE
3rd row	Large&sunnyflatwithbalcony!
4th row	Cozy,CentralParis:WALKorVELIBEVERYWHERE!
5th row	Parispetitcoindouillet

Common Values

Value	Count	Frequency (%)
StudiointheheartofParis	8	0.1%
CosyflatinMontmartre	7	0.1%
CharmingflatnearMontmartre	6	0.1%
CharmingflatintheheartofParis	5	0.1%
CharmingflatinMontmartre	5	0.1%
AppartementprocheTourEiffel	4	< 0.1%
NicestudionearMontmartre	4	< 0.1%
CharmingapartmentinParis	4	< 0.1%
Appartementdecharme	4	< 0.1%
ApartmentintheheartofParis	3	< 0.1%
Other values (9781)	9919	99.2%
(Missing)	30	0.3%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
studiointheheartofparis	10	0.1%
charmingflatnearmontmartre	8	0.1%
charmingflatinmontmartre	7	0.1%
cosyflatinmontmartre	7	0.1%
cosyflatintheheartofparis	7	0.1%
charmingflatintheheartofparis	5	0.1%
appartementprochetoureiffel	5	0.1%
charmingparisianapartment	5	0.1%
cosystudiointheheartofparis	5	0.1%
charmantstudioparisien	5	0.1%
Other values (9670)	9907	99.4%

Most occurring characters

Value	Count	Frequency (%)
No values found.

Most occurring categories

Value	Count	Frequency (%)
No values found.

Most frequent character per category

Most occurring scripts

Value	Count	Frequency (%)
No values found.

Most frequent character per script

Most occurring blocks

Value	Count	Frequency (%)
No values found.

Most frequent character per block

host_id
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION

Distinct	9339
Distinct (%)	93.4%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	18286906.49

Minimum	2626
Maximum	421961718
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	78.2 KiB

Quantile statistics

Minimum	2626
5-th percentile	1328190
Q1	6049837.5
median	14081535
Q3	28230128.5
95-th percentile	42786637
Maximum	421961718
Range	421959092
Interquartile range (IQR)	22180291

Descriptive statistics

Standard deviation	21472593.69
Coefficient of variation (CV)	1.17420591
Kurtosis	158.8444001
Mean	18286906.49
Median Absolute Deviation (MAD)	9709251
Skewness	9.782402755
Sum	1.82850778 × 10¹¹
Variance	4.610722797 × 10¹⁴
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
7642792	63	0.6%
152242	27	0.3%
656386	20	0.2%
5027164	20	0.2%
7608379	18	0.2%
3971743	15	0.2%
7612270	9	0.1%
24495283	8	0.1%
13013633	8	0.1%
10341787	8	0.1%
Other values (9329)	9803	98.0%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
2626	2	< 0.1%
7903	1	< 0.1%
20633	1	< 0.1%
22155	1	< 0.1%
28422	1	< 0.1%
29666	1	< 0.1%
33534	1	< 0.1%
37107	3	< 0.1%
38818	2	< 0.1%
39402	1	< 0.1%

Value	Count	Frequency (%)
421961718	1	< 0.1%
421961057	2	< 0.1%
418132154	3	< 0.1%
408860099	1	< 0.1%
402191311	4	< 0.1%
349213863	1	< 0.1%
331327228	1	< 0.1%
326358725	1	< 0.1%
311372920	1	< 0.1%
291007369	3	< 0.1%

host_name
Categorical

HIGH CARDINALITY

Distinct	2851
Distinct (%)	28.5%
Missing	8
Missing (%)	0.1%
Memory size	78.2 KiB

Marie	109
Anne	87
Pierre	81
Sophie	81
Nicolas	77
Other values (2846)	9556

Length

Max length	28
Median length	6
Mean length	6.947252527
Min length	1

Characters and Unicode

Total characters	0
Distinct characters	0
Distinct categories	0 ?
Distinct scripts	0 ?
Distinct blocks	0 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	1825 ?
Unique (%)	18.3%

Sample

1st row	Borzou
2nd row	Franck
3rd row	Anaïs
4th row	Bernadette
5th row	Elisabeth

Common Values

Value	Count	Frequency (%)
Marie	109	1.1%
Anne	87	0.9%
Pierre	81	0.8%
Sophie	81	0.8%
Nicolas	77	0.8%
Julien	74	0.7%
Ludovic	72	0.7%
Claire	71	0.7%
Thomas	71	0.7%
Catherine	70	0.7%
Other values (2841)	9198	92.0%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
marie	109	1.1%
anne	87	0.9%
pierre	81	0.8%
sophie	81	0.8%
nicolas	77	0.8%
julien	74	0.7%
ludovic	72	0.7%
claire	71	0.7%
thomas	71	0.7%
catherine	70	0.7%
Other values (2839)	9198	92.1%

Most occurring characters

Value	Count	Frequency (%)
No values found.

Most occurring categories

Value	Count	Frequency (%)
No values found.

Most frequent character per category

Most occurring scripts

Value	Count	Frequency (%)
No values found.

Most frequent character per script

Most occurring blocks

Value	Count	Frequency (%)
No values found.

Most frequent character per block

neighbourhood
Categorical

HIGH CORRELATION

Distinct	20
Distinct (%)	0.2%
Missing	0
Missing (%)	0.0%
Memory size	78.2 KiB

Buttes-Montmartre	1133
Popincourt	1001
Entrepôt	768
Vaugirard	730
Ménilmontant	645
Other values (15)	5722

Length

Max length	19
Median length	10
Mean length	10.67706771
Min length	5

Characters and Unicode

Total characters	0
Distinct characters	0
Distinct categories	0 ?
Distinct scripts	0 ?
Distinct blocks	0 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	Hôtel-de-Ville
2nd row	Hôtel-de-Ville
3rd row	Opéra
4th row	Louvre
5th row	Popincourt

Common Values

Value	Count	Frequency (%)
Buttes-Montmartre	1133	11.3%
Popincourt	1001	10.0%
Entrepôt	768	7.7%
Vaugirard	730	7.3%
Ménilmontant	645	6.5%
Batignolles-Monceau	593	5.9%
Buttes-Chaumont	590	5.9%
Opéra	473	4.7%
Temple	449	4.5%
Passy	448	4.5%
Other values (10)	3169	31.7%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
buttes-montmartre	1133	11.3%
popincourt	1001	10.0%
entrepôt	768	7.7%
vaugirard	730	7.3%
ménilmontant	645	6.5%
batignolles-monceau	593	5.9%
buttes-chaumont	590	5.9%
opéra	473	4.7%
temple	449	4.5%
passy	448	4.5%
Other values (10)	3169	31.7%

Most occurring characters

Value	Count	Frequency (%)
No values found.

Most occurring categories

Value	Count	Frequency (%)
No values found.

Most frequent character per category

Most occurring scripts

Value	Count	Frequency (%)
No values found.

Most frequent character per script

Most occurring blocks

Value	Count	Frequency (%)
No values found.

Most frequent character per block

latitude
Real number (ℝ_≥0)

HIGH CORRELATION

Distinct	5282
Distinct (%)	52.8%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	48.86395155

Minimum	48.81714
Maximum	48.90075
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	78.2 KiB

Quantile statistics

Minimum	48.81714
5-th percentile	48.832198
Q1	48.851025
median	48.86492
Q3	48.87883
95-th percentile	48.891311
Maximum	48.90075
Range	0.08361
Interquartile range (IQR)	0.027805

Descriptive statistics

Standard deviation	0.01813592432
Coefficient of variation (CV)	0.000371151406
Kurtosis	-0.7580695136
Mean	48.86395155
Median Absolute Deviation (MAD)	0.0139
Skewness	-0.2302105864
Sum	488590.6515
Variance	0.000328911751
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
48.88092	8	0.1%
48.86371	8	0.1%
48.86845	8	0.1%
48.8477	7	0.1%
48.86479	7	0.1%
48.86041	7	0.1%
48.86868	7	0.1%
48.87085	7	0.1%
48.85817	7	0.1%
48.86114	7	0.1%
Other values (5272)	9926	99.3%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
48.81714	1	< 0.1%
48.81723	1	< 0.1%
48.81724	1	< 0.1%
48.81792	1	< 0.1%
48.81837	1	< 0.1%
48.81882	1	< 0.1%
48.81892	1	< 0.1%
48.81895	1	< 0.1%
48.81902	1	< 0.1%
48.81917	1	< 0.1%

Value	Count	Frequency (%)
48.90075	1	< 0.1%
48.90068	1	< 0.1%
48.89981	1	< 0.1%
48.89974	1	< 0.1%
48.89934	1	< 0.1%
48.89927	1	< 0.1%
48.89925	1	< 0.1%
48.89912	1	< 0.1%
48.899	1	< 0.1%
48.89895	1	< 0.1%

longitude
Real number (ℝ_≥0)

HIGH CORRELATION

Distinct	6786
Distinct (%)	67.9%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	2.347086234

Minimum	2.23549
Maximum	2.46705
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	78.2 KiB

Quantile statistics

Minimum	2.23549
5-th percentile	2.286808
Q1	2.32767
median	2.34976
Q3	2.371705
95-th percentile	2.396456
Maximum	2.46705
Range	0.23156
Interquartile range (IQR)	0.044035

Descriptive statistics

Standard deviation	0.03266944532
Coefficient of variation (CV)	0.01391914999
Kurtosis	-0.262756909
Mean	2.347086234
Median Absolute Deviation (MAD)	0.022
Skewness	-0.4132909795
Sum	23468.51525
Variance	0.001067292657
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
2.33719	8	0.1%
2.34817	7	0.1%
2.34728	6	0.1%
2.35307	6	0.1%
2.35835	6	0.1%
2.38194	6	0.1%
2.35114	5	0.1%
2.34985	5	0.1%
2.34977	5	0.1%
2.34979	5	0.1%
Other values (6776)	9940	99.4%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
2.23549	1	< 0.1%
2.23739	1	< 0.1%
2.23838	1	< 0.1%
2.24843	1	< 0.1%
2.2511	1	< 0.1%
2.25162	1	< 0.1%
2.25173	1	< 0.1%
2.251815	1	< 0.1%
2.25201	1	< 0.1%
2.25258	1	< 0.1%

Value	Count	Frequency (%)
2.46705	1	< 0.1%
2.46574	1	< 0.1%
2.46192	1	< 0.1%
2.44071	1	< 0.1%
2.43262	1	< 0.1%
2.42872	1	< 0.1%
2.42258	1	< 0.1%
2.42242	1	< 0.1%
2.42177	1	< 0.1%
2.41533	1	< 0.1%

room_type
Categorical

Distinct	4
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	78.2 KiB

Entirehome/apt	8620
Privateroom	1335
Sharedroom	40
Hotelroom	4

Length

Max length	14
Median length	14
Mean length	13.58145815
Min length	9

Characters and Unicode

Total characters	0
Distinct characters	0
Distinct categories	0 ?
Distinct scripts	0 ?
Distinct blocks	0 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	Entirehome/apt
2nd row	Entirehome/apt
3rd row	Entirehome/apt
4th row	Entirehome/apt
5th row	Entirehome/apt

Common Values

Value	Count	Frequency (%)
Entirehome/apt	8620	86.2%
Privateroom	1335	13.4%
Sharedroom	40	0.4%
Hotelroom	4	< 0.1%

Length

Histogram of lengths of the category

Pie chart

Value	Count	Frequency (%)
entirehome/apt	8620	86.2%
privateroom	1335	13.4%
sharedroom	40	0.4%
hotelroom	4	< 0.1%

Most occurring characters

Value	Count	Frequency (%)
No values found.

Most occurring categories

Value	Count	Frequency (%)
No values found.

Most frequent character per category

Most occurring scripts

Value	Count	Frequency (%)
No values found.

Most frequent character per script

Most occurring blocks

Value	Count	Frequency (%)
No values found.

Most frequent character per block

price
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
SKEWED

Distinct	418
Distinct (%)	4.2%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	114.3091309

Minimum	8
Maximum	8000
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	78.2 KiB

Quantile statistics

Minimum	8
5-th percentile	37.9
Q1	60
median	83
Q3	125
95-th percentile	265
Maximum	8000
Range	7992
Interquartile range (IQR)	65

Descriptive statistics

Standard deviation	188.0536918
Coefficient of variation (CV)	1.645132723
Kurtosis	983.9845252
Mean	114.3091309
Median Absolute Deviation (MAD)	28
Skewness	26.55905346
Sum	1142977
Variance	35364.19099
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
60	481	4.8%
70	450	4.5%
80	441	4.4%
50	423	4.2%
100	393	3.9%
90	370	3.7%
65	296	3.0%
75	288	2.9%
120	275	2.8%
150	236	2.4%
Other values (408)	6346	63.5%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
8	2	< 0.1%
9	1	< 0.1%
10	1	< 0.1%
11	1	< 0.1%
13	1	< 0.1%
15	2	< 0.1%
17	2	< 0.1%
19	2	< 0.1%
20	17	0.2%
21	3	< 0.1%

Value	Count	Frequency (%)
8000	2	< 0.1%
7000	1	< 0.1%
6742	1	< 0.1%
4000	1	< 0.1%
3000	1	< 0.1%
2450	1	< 0.1%
2325	1	< 0.1%
2200	1	< 0.1%
2000	1	< 0.1%
1615	1	< 0.1%

minimum_nights
Real number (ℝ_≥0)

HIGH CORRELATION

Distinct	57
Distinct (%)	0.6%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	155.8558856

Minimum	1
Maximum	9999
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	78.2 KiB

Quantile statistics

Minimum	1
5-th percentile	1
Q1	3
median	8
Q3	365
95-th percentile	365
Maximum	9999
Range	9998
Interquartile range (IQR)	362

Descriptive statistics

Standard deviation	201.925913
Coefficient of variation (CV)	1.295593761
Kurtosis	562.7964213
Mean	155.8558856
Median Absolute Deviation (MAD)	7
Skewness	11.82121482
Sum	1558403
Variance	40774.07435
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
365	4092	40.9%
3	1238	12.4%
2	1170	11.7%
1	793	7.9%
4	674	6.7%
5	583	5.8%
30	449	4.5%
7	308	3.1%
6	230	2.3%
91	58	0.6%
Other values (47)	404	4.0%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
1	793	7.9%
2	1170	11.7%
3	1238	12.4%
4	674	6.7%
5	583	5.8%
6	230	2.3%
7	308	3.1%
8	22	0.2%
9	8	0.1%
10	52	0.5%

Value	Count	Frequency (%)
9999	1	< 0.1%
1000	2	< 0.1%
500	1	< 0.1%
400	2	< 0.1%
365	4092	40.9%
360	2	< 0.1%
300	1	< 0.1%
270	6	0.1%
183	1	< 0.1%
180	7	0.1%

number_of_reviews
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
ZEROS

Distinct	396
Distinct (%)	4.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	39.86358636

Minimum	0
Maximum	823
Zeros	1958
Zeros (%)	19.6%
Negative	0
Negative (%)	0.0%
Memory size	78.2 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	1
median	12
Q3	47
95-th percentile	174.1
Maximum	823
Range	823
Interquartile range (IQR)	46

Descriptive statistics

Standard deviation	69.88208565
Coefficient of variation (CV)	1.753030573
Kurtosis	18.44843883
Mean	39.86358636
Median Absolute Deviation (MAD)	12
Skewness	3.577723914
Sum	398596
Variance	4883.505894
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	1958	19.6%
1	663	6.6%
2	458	4.6%
3	333	3.3%
4	275	2.8%
5	245	2.5%
6	199	2.0%
8	172	1.7%
9	170	1.7%
7	168	1.7%
Other values (386)	5358	53.6%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	1958	19.6%
1	663	6.6%
2	458	4.6%
3	333	3.3%
4	275	2.8%
5	245	2.5%
6	199	2.0%
7	168	1.7%
8	172	1.7%
9	170	1.7%

Value	Count	Frequency (%)
823	1	< 0.1%
817	1	< 0.1%
772	1	< 0.1%
695	1	< 0.1%
676	1	< 0.1%
674	1	< 0.1%
647	1	< 0.1%
621	1	< 0.1%
593	2	< 0.1%
589	2	< 0.1%

last_review
Categorical

HIGH CARDINALITY
MISSING

Distinct	2010
Distinct (%)	25.0%
Missing	1958
Missing (%)	19.6%
Memory size	78.2 KiB

02-01-2022	195
01-01-2022	108
03-01-2022	93
30-12-2021	80
12-12-2021	75
Other values (2005)	7490

Length

Max length	10
Median length	10
Mean length	10
Min length	10

Characters and Unicode

Total characters	0
Distinct characters	0
Distinct categories	0 ?
Distinct scripts	0 ?
Distinct blocks	0 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	713 ?
Unique (%)	8.9%

Sample

1st row	04-01-2022
2nd row	30-12-2021
3rd row	14-09-2015
4th row	28-12-2021
5th row	27-09-2021

Common Values

Value	Count	Frequency (%)
02-01-2022	195	2.0%
01-01-2022	108	1.1%
03-01-2022	93	0.9%
30-12-2021	80	0.8%
12-12-2021	75	0.8%
23-12-2021	73	0.7%
26-12-2021	69	0.7%
31-12-2021	66	0.7%
19-12-2021	59	0.6%
22-12-2021	55	0.6%
Other values (2000)	7168	71.7%
(Missing)	1958	19.6%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
02-01-2022	195	2.4%
01-01-2022	108	1.3%
03-01-2022	93	1.2%
30-12-2021	80	1.0%
12-12-2021	75	0.9%
23-12-2021	73	0.9%
26-12-2021	69	0.9%
31-12-2021	66	0.8%
19-12-2021	59	0.7%
22-12-2021	55	0.7%
Other values (2000)	7168	89.1%

Most occurring characters

Value	Count	Frequency (%)
No values found.

Most occurring categories

Value	Count	Frequency (%)
No values found.

Most frequent character per category

Most occurring scripts

Value	Count	Frequency (%)
No values found.

Most frequent character per script

Most occurring blocks

Value	Count	Frequency (%)
No values found.

Most frequent character per block

reviews_per_month
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
MISSING

Distinct	428
Distinct (%)	5.3%
Missing	1958
Missing (%)	19.6%
Infinite	0
Infinite (%)	0.0%
Mean	0.5801392862

Minimum	0.01
Maximum	8.14
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	78.2 KiB

Quantile statistics

Minimum	0.01
5-th percentile	0.01
Q1	0.08
median	0.28
Q3	0.74
95-th percentile	2.21
Maximum	8.14
Range	8.13
Interquartile range (IQR)	0.66

Descriptive statistics

Standard deviation	0.8272541979
Coefficient of variation (CV)	1.4259579
Kurtosis	13.98639877
Mean	0.5801392862
Median Absolute Deviation (MAD)	0.24
Skewness	3.113904174
Sum	4664.9
Variance	0.684349508
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0.01	516	5.2%
0.03	361	3.6%
0.04	287	2.9%
0.05	242	2.4%
0.02	206	2.1%
0.06	180	1.8%
0.09	161	1.6%
0.07	153	1.5%
0.08	153	1.5%
0.1	142	1.4%
Other values (418)	5640	56.4%
(Missing)	1958	19.6%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0.01	516	5.2%
0.02	206	2.1%
0.03	361	3.6%
0.04	287	2.9%
0.05	242	2.4%
0.06	180	1.8%
0.07	153	1.5%
0.08	153	1.5%
0.09	161	1.6%
0.1	142	1.4%

Value	Count	Frequency (%)
8.14	1	< 0.1%
8.09	1	< 0.1%
7.92	1	< 0.1%
7.71	1	< 0.1%
7.58	1	< 0.1%
7.43	1	< 0.1%
7.36	1	< 0.1%
7.28	1	< 0.1%
7.01	1	< 0.1%
6.93	1	< 0.1%

calculated_host_listings_count
Real number (ℝ_≥0)

Distinct	41
Distinct (%)	0.4%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	3.457045705

Minimum	1
Maximum	265
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	78.2 KiB

Quantile statistics

Minimum	1
5-th percentile	1
Q1	1
median	1
Q3	1
95-th percentile	3
Maximum	265
Range	264
Interquartile range (IQR)	0

Descriptive statistics

Standard deviation	17.73795527
Coefficient of variation (CV)	5.130957698
Kurtosis	107.3835758
Mean	3.457045705
Median Absolute Deviation (MAD)	0
Skewness	9.996236457
Sum	34567
Variance	314.6350571
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=41)

Value	Count	Frequency (%)
1	8550	85.5%
2	814	8.1%
3	167	1.7%
197	63	0.6%
5	47	0.5%
4	44	0.4%
69	27	0.3%
36	26	0.3%
23	22	0.2%
81	20	0.2%
Other values (31)	219	2.2%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
1	8550	85.5%
2	814	8.1%
3	167	1.7%
4	44	0.4%
5	47	0.5%
6	19	0.2%
7	12	0.1%
8	16	0.2%
9	10	0.1%
10	11	0.1%

Value	Count	Frequency (%)
265	4	< 0.1%
197	63	0.6%
87	5	0.1%
85	4	< 0.1%
82	6	0.1%
81	20	0.2%
71	3	< 0.1%
69	27	0.3%
61	2	< 0.1%
52	8	0.1%

availability_365
Real number (ℝ_≥0)

HIGH CORRELATION
ZEROS

Distinct	366
Distinct (%)	3.7%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	87.65736574

Minimum	0
Maximum	365
Zeros	5721
Zeros (%)	57.2%
Negative	0
Negative (%)	0.0%
Memory size	78.2 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0
Q3	179
95-th percentile	363
Maximum	365
Range	365
Interquartile range (IQR)	179

Descriptive statistics

Standard deviation	129.4912291
Coefficient of variation (CV)	1.47724299
Kurtosis	-0.3544987148
Mean	87.65736574
Median Absolute Deviation (MAD)	0
Skewness	1.12418884
Sum	876486
Variance	16767.97841
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	5721	57.2%
365	280	2.8%
364	143	1.4%
363	95	1.0%
358	67	0.7%
8	66	0.7%
9	63	0.6%
362	56	0.6%
193	41	0.4%
192	40	0.4%
Other values (356)	3427	34.3%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	5721	57.2%
1	36	0.4%
2	33	0.3%
3	10	0.1%
4	16	0.2%
5	19	0.2%
6	15	0.2%
7	25	0.3%
8	66	0.7%
9	63	0.6%

Value	Count	Frequency (%)
365	280	2.8%
364	143	1.4%
363	95	1.0%
362	56	0.6%
361	10	0.1%
360	12	0.1%
359	19	0.2%
358	67	0.7%
357	17	0.2%
356	9	0.1%

number_of_reviews_ltm
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
ZEROS

Distinct	72
Distinct (%)	0.7%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	2.522552255

Minimum	0
Maximum	97
Zeros	6974
Zeros (%)	69.7%
Negative	0
Negative (%)	0.0%
Memory size	78.2 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0
Q3	2
95-th percentile	14
Maximum	97
Range	97
Interquartile range (IQR)	2

Descriptive statistics

Standard deviation	6.743171399
Coefficient of variation (CV)	2.673154296
Kurtosis	34.0378495
Mean	2.522552255
Median Absolute Deviation (MAD)	0
Skewness	4.921242881
Sum	25223
Variance	45.47036052
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	6974	69.7%
1	495	5.0%
2	401	4.0%
3	299	3.0%
4	250	2.5%
5	208	2.1%
6	162	1.6%
8	144	1.4%
7	131	1.3%
9	95	1.0%
Other values (62)	840	8.4%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	6974	69.7%
1	495	5.0%
2	401	4.0%
3	299	3.0%
4	250	2.5%
5	208	2.1%
6	162	1.6%
7	131	1.3%
8	144	1.4%
9	95	1.0%

Value	Count	Frequency (%)
97	1	< 0.1%
95	1	< 0.1%
80	1	< 0.1%
77	1	< 0.1%
75	1	< 0.1%
70	1	< 0.1%
67	1	< 0.1%
66	1	< 0.1%
65	1	< 0.1%
64	1	< 0.1%

log_price
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION

Distinct	418
Distinct (%)	4.2%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	4.490776574

Minimum	2.079441542
Maximum	8.987196821
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	78.2 KiB

Quantile statistics

Minimum	2.079441542
5-th percentile	3.634919335
Q1	4.094344562
median	4.418840608
Q3	4.828313737
95-th percentile	5.579729826
Maximum	8.987196821
Range	6.907755279
Interquartile range (IQR)	0.7339691751

Descriptive statistics

Standard deviation	0.6148088419
Coefficient of variation (CV)	0.136904794
Kurtosis	2.365150144
Mean	4.490776574
Median Absolute Deviation (MAD)	0.368651135
Skewness	0.8514394563
Sum	44903.27497
Variance	0.377989912
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
4.094344562	481	4.8%
4.248495242	450	4.5%
4.382026635	441	4.4%
3.912023005	423	4.2%
4.605170186	393	3.9%
4.49980967	370	3.7%
4.17438727	296	3.0%
4.317488114	288	2.9%
4.787491743	275	2.8%
4.007333185	236	2.4%
Other values (408)	6346	63.5%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
2.079441542	2	< 0.1%
2.197224577	1	< 0.1%
2.302585093	1	< 0.1%
2.397895273	1	< 0.1%
2.564949357	1	< 0.1%
2.708050201	2	< 0.1%
2.833213344	2	< 0.1%
2.944438979	2	< 0.1%
2.995732274	17	0.2%
3.044522438	3	< 0.1%

Value	Count	Frequency (%)
8.987196821	2	< 0.1%
8.853665428	1	< 0.1%
8.816111896	1	< 0.1%
8.29404964	1	< 0.1%
8.006367568	1	< 0.1%
7.803843304	1	< 0.1%
7.751475318	1	< 0.1%
7.696212639	1	< 0.1%
7.60090246	1	< 0.1%
7.387090236	1	< 0.1%

Spearman's ρ

The Spearman's rank correlation coefficient (ρ) is a measure of monotonic correlation between two variables, and is therefore better in catching nonlinear monotonic correlations than Pearson's r. It's value lies between -1 and +1, -1 indicating total negative monotonic correlation, 0 indicating no monotonic correlation and 1 indicating total positive monotonic correlation.

To calculate ρ for two variables X and Y, one divides the covariance of the rank variables of X and Y by the product of their standard deviations.

Pearson's r

The Pearson's correlation coefficient (r) is a measure of linear correlation between two variables. It's value lies between -1 and +1, -1 indicating total negative linear correlation, 0 indicating no linear correlation and 1 indicating total positive linear correlation. Furthermore, r is invariant under separate changes in location and scale of the two variables, implying that for a linear function the angle to the x-axis does not affect r.

To calculate r for two variables X and Y, one divides the covariance of X and Y by the product of their standard deviations.

Kendall's τ

Similarly to Spearman's rank correlation coefficient, the Kendall rank correlation coefficient (τ) measures ordinal association between two variables. It's value lies between -1 and +1, -1 indicating total negative correlation, 0 indicating no correlation and 1 indicating total positive correlation.

To calculate τ for two variables X and Y, one determines the number of concordant and discordant pairs of observations. τ is given by the number of concordant pairs minus the discordant pairs divided by the total number of pairs.

Cramér's V (φc)

Cramér's V is an association measure for nominal random variables. The coefficient ranges from 0 to 1, with 0 indicating independence and 1 indicating perfect association. The empirical estimators used for Cramér's V have been proved to be biased, even for large samples. We use a bias-corrected measure that has been proposed by Bergsma in 2013 that can be found here.

Phik (φk)

Phik (φk) is a new and practical correlation coefficient that works consistently between categorical, ordinal and interval variables, captures non-linear dependency and reverts to the Pearson correlation coefficient in case of a bivariate normal input distribution. There is extensive documentation available here.

A simple visualization of nullity by column.

Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.

The correlation heatmap measures nullity correlation: how strongly the presence or absence of one variable affects the presence of another.

The dendrogram allows you to more fully correlate variable completion, revealing trends deeper than the pairwise ones visible in the correlation heatmap.

First rows

	id	name	host_id	host_name	neighbourhood	latitude	longitude	room_type	price	minimum_nights	number_of_reviews	last_review	reviews_per_month	calculated_host_listings_count	availability_365	number_of_reviews_ltm	log_price
0	5396	ExploretheheartofoldParis	7903	Borzou	Hôtel-de-Ville	48.852470	2.358350	Entirehome/apt	80	2	277	04-01-2022	1.82	1	66	45	4.382027
1	7397	MARAIS-2ROOMSAPT-2/4PEOPLE	2626	Franck	Hôtel-de-Ville	48.859090	2.353150	Entirehome/apt	105	10	290	30-12-2021	2.21	4	212	20	4.653960
2	7964	Large&sunnyflatwithbalcony!	22155	Anaïs	Opéra	48.874170	2.342450	Entirehome/apt	130	6	6	14-09-2015	0.04	1	365	0	4.867534
3	9359	Cozy,CentralParis:WALKorVELIBEVERYWHERE!	28422	Bernadette	Louvre	48.860060	2.348630	Entirehome/apt	75	180	0	NaN	NaN	1	148	0	4.317488
4	9952	Parispetitcoindouillet	33534	Elisabeth	Popincourt	48.863730	2.370930	Entirehome/apt	80	4	34	28-12-2021	0.32	1	212	8	4.382027
5	10586	Studio7Montmartre	37107	Michael	Buttes-Montmartre	48.889020	2.346560	Entirehome/apt	80	30	49	27-09-2021	0.33	4	173	1	4.382027
6	10588	Studio10Montmartre	37107	Michael	Buttes-Montmartre	48.889180	2.344900	Entirehome/apt	75	30	19	10-09-2021	0.14	4	204	3	4.317488
7	10917	ELYSEES-PONCELETFLATNEARCH.ELYS	39402	Isabelle	Batignolles-Monceau	48.879074	2.296904	Entirehome/apt	143	30	25	01-12-2016	0.17	1	0	0	4.962845
8	11213	DOWNTOWNPARIS	41322	Mathieu	Entrepôt	48.871090	2.373760	Privateroom	157	1	152	27-12-2021	1.91	2	284	3	5.056246
9	11265	ElegantappartmentinMontmartre	41718	Sylvie	Buttes-Montmartre	48.884940	2.339970	Entirehome/apt	100	7	16	01-10-2019	0.24	1	122	0	4.605170

Last rows

	id	name	host_id	host_name	neighbourhood	latitude	longitude	room_type	price	minimum_nights	number_of_reviews	last_review	reviews_per_month	calculated_host_listings_count	availability_365	number_of_reviews_ltm	log_price
9989	9486388	Charmingflatwithbeautifulview	13729717	Louise	Buttes-Montmartre	48.88584	2.36541	Entirehome/apt	32	5	12	16-08-2018	0.17	1	0	0	3.465736
9990	9486445	AmazingviewstudioNotreDame	49166922	Hélène	Hôtel-de-Ville	48.85402	2.35093	Entirehome/apt	120	2	133	19-12-2021	1.89	1	282	25	4.787492
9991	9487232	NaN	27822742	Aymeric	Vaugirard	48.83931	2.30737	Entirehome/apt	65	365	2	17-05-2016	0.03	1	0	0	4.174387
9992	9487360	Well-appointedSt.Michelstudio	3399907	Melissa	Luxembourg	48.85218	2.34163	Entirehome/apt	75	365	186	30-09-2021	2.65	2	356	5	4.317488
9993	9487619	Flatforfamily	11678014	Sonia	Batignolles-Monceau	48.88835	2.29381	Entirehome/apt	99	365	0	NaN	NaN	1	0	0	4.595120
9994	9487739	Opéracharmantappartement!	10714020	Martin	Opéra	48.87426	2.32775	Entirehome/apt	50	365	15	16-10-2016	0.20	1	0	0	3.912023
9995	9487744	Studiolumineuxetbienagencé	49174455	Charlotte	Batignolles-Monceau	48.88973	2.32476	Entirehome/apt	50	365	0	NaN	NaN	1	0	0	3.912023
9996	9488190	CosyBright&SereneStudio.	49176747	Jesus	Buttes-Chaumont	48.87649	2.38633	Entirehome/apt	70	30	27	16-12-2020	0.38	1	183	0	4.248495
9997	9489895	LovelyStudionearBastille	49184991	Simon	Reuilly	48.85110	2.37360	Entirehome/apt	52	365	1	28-11-2015	0.01	1	0	0	3.951244
9998	9492265	CosyflatinMontmartre	15715264	Sophie	Buttes-Montmartre	48.89439	2.34173	Entirehome/apt	75	365	0	NaN	NaN	1	0	0	4.317488

Overview

Variables

Common Values

Length

Most occurring characters

Most occurring categories

Most frequent character per category

Most occurring scripts

Most frequent character per script

Most occurring blocks

Most frequent character per block

Common Values

Length

Most occurring characters

Most occurring categories

Most frequent character per category

Most occurring scripts

Most frequent character per script

Most occurring blocks

Most frequent character per block

Common Values

Length

Most occurring characters

Most occurring categories

Most frequent character per category

Most occurring scripts

Most frequent character per script

Most occurring blocks

Most frequent character per block

Common Values

Length

Pie chart

Most occurring characters

Most occurring categories

Most frequent character per category

Most occurring scripts

Most frequent character per script

Most occurring blocks

Most frequent character per block

Common Values

Length

Most occurring characters

Most occurring categories

Most frequent character per category

Most occurring scripts

Most frequent character per script

Most occurring blocks

Most frequent character per block

Interactions

Correlations

Spearman's ρ

Pearson's r

Kendall's τ

Cramér's V (φc)

Phik (φk)

Missing values

Sample

First rows

Last rows